CREATE TABLE MOVIE ( MOVIE_ID NUMBER(15, 0) NOT NULL , SERIAL_NUMBER NUMBER(15, 0) , DISCOUNT NUMBER(3, 2) ,GENRE VARCHAR(64),MOVIE_TITLE VARCHAR(64),AWARD VARCHAR(64) , CAST VARCHAR(1024), CONSTRAINT MOVIE_PK PRIMARY KEY ( MOVIE_ID ) ENABLE );

INSERT INTO MOVIE VALUES ();// Five entries were used here

CREATE TABLE DVD ( DVD_ID NUMBER(15,0), DVD_QUANTITY NUMBER(15, 0) NOT NULL , DVD_PRICE NUMBER(8, 2) , DVD_TITLE VARCHAR(64) ,CONSTRAINT DVD_PK PRIMARY KEY ( DVD_ID ) ENABLE );

INSERT INTO DVD VALUES ();// Five entries were used here

CREATE TABLE VIDEO ( VIDEO_ID NUMBER(15, 0) NOT NULL , SERIAL_NUMBER NUMBER(15, 0) , VIDEO_PRICE VARCHAR(64) , VIDEO_QUANTITY VARCHAR(1024) , CONSTRAINT VIDEO_PK PRIMARY KEY ( VIDEO_ID ) ENABLE );

INSERT INTO VIDEO VALUES ();// Five entries were used here

CREATE TABLE DISTRIBUTOR ( SERIAL_NUMBER NUMBER(15, 0) NOT NULL ,WAREHOUSE NUMBER(11, 0) , PRICE NUMBER(15, 0) ,GENRE VARCHAR(60) ,DISTRIBUTOR_NAME VARCHAR(15), CONSTRAINT DISTRIBUTOR_PK PRIMARY KEY ( WAREHOUSE ) ENABLE );

INSERT INTO DISTRIBUTOR VALUES ();// Five entries were used here

CREATE TABLE ORDER ( RETURN_DATE NUMBER(15, 0) NOT NULL , ORDER_DATE NUMBER(15,0) , ORDER_ID NUMBER(15, 0) , CONSTRAINT ORDER_PK PRIMARY KEY ( ORDER_ID ) ENABLE );

INSERT INTO ORDER VALUES ();// Five entries were used here

CREATE TABLE CUSTOMER ( CUSTOMER_ID NUMBER(15, 0) NOT NULL , PHONE NUMBER (15, 0) , NAME VARCHAR(64) , ADDRESS VARCHAR2(128) , CONSTRAINT CUSTOMER_PK PRIMARY KEY ( CUSTOMER_ID ) ENABLE );

INSERT INTO CUSTOMER VALUES ();// Five entries were used here

CREATE TABLE FEE ( FEE_ID NUMBER(11, 0) NOT NULL , REWIND_FEE NUMBER(8, 2) , LATE_FEE NUMBER(8, 2) , DAMAGE_FEE NUMBER(8, 2) ,CONSTRAINT FEE_PK PRIMARY KEY ( FEE_ID ) ENABLE );

INSERT INTO FEE VALUES ();// Five entries were used here

alter table "YOURNAME"."ORDER" add constraint fk_dvd foreign key("DVD_ID") references "DVD"("DVD_ID")

alter table "YOURNAME"."ORDER" add constraint fk_video foreign key("VIDEO_ID") references "VIDEO"("VIDEO_ID")

alter table "YOURNAME"."ORDER" add constraint fk_customer foreign key("CUSTOMER_ID") references "VIDEO"("CUSTOMER_ID")

alter table "YOURNAME"."CUSTOMER" add constraint fk_fee foreign key("FEE_ID") references "FEE"("FEE_ID")

alter table "YOURNAME"."CUSTOMER" add constraint fk_order foreign key("ORDER_ID") references "ORDER"("ORDER_ID")

alter table "YOURNAME"."VIDEO" add constraint fk_movie foreign key("MOVIE_ID") references "MOVIE"("MOVIE_ID")

alter table "YOURNAME"."VIDEO" add constraint fk_movie foreign key("MOVIE_CAST") references "MOVIE"("MOVIE_CAST")

alter table "YOURNAME"."VIDEO" add constraint fk_movie foreign key("MOVIE_AWARD") references "MOVIE"("MOVIE_AWARD")

alter table "YOURNAME"."VIDEO" add constraint fk_movie foreign key("VIDEO_GENRE") references "MOVIE"("GENRE")

alter table "YOURNAME"."VIDEO" add constraint fk_movie foreign key("DISCOUNT") references "MOVIE"("DISCOUNT") 

alter table "YOURNAME"."DVD" add constraint fk_movie foreign key("DISCOUNT") references "MOVIE"("DISCOUNT")

alter table "YOURNAME"."DVD" add constraint fk_movie foreign key("MOVIE_AWARD") references "MOVIE"("AWARD")

alter table "YOURNAME"."DVD" add constraint fk_movie foreign key("MOVIE_CAST") references "MOVIE"("CAST")

alter table "YOURNAME"."DVD" add constraint fk_movie foreign key("DVD_GENRE") references "MOVIE"("GENRE")

alter table "YOURNAME"."DVD" add constraint fk_movie foreign key("MOVIE_ID") references "MOVIE"("MOVIE_ID")